"Timeout Expired" error on DTS execution

[Joshua Conroy]

Hello,

I am using a VB script active task object in a DTS package
to connect to one of my databases using an OLE DB connection.
I send an SQL string executing stored procedures, and depending
on the size of the procedures I get a "Timeout Expired" error
on execution of the DTS package. I have trimmed and tuned the
stored procedures to be much smaller and faster, but still
haven't beaten the timeout. How do i avoid, switch off, or
lengthen the timeout period?

Thanks, Joshua

PS, alternately, how might I modify the parameters of and execute
DTS packages from stored procedures?

[Neale NOON]

Greetings Joshua,

There are several places that certain timeouts may be configured but because you are connecting to a dadabase server, from within your DTS activeX sctipt, then this could be related to the "CommandTimeout property (ADO)" check it out in the MSDN Library.

CommandTimeout defaults to 30 seconds and can be set for a Command Object or also for a Connection Object.

Regards,
Neale NOON


------------
Joshua Conroy at 1/22/01 7:02:49 PM

Hello,

I am using a VB script active task object in a DTS package
to connect to one of my databases using an OLE DB connection.
I send an SQL string executing stored procedures, and depending
on the size of the procedures I get a "Timeout Expired" error
on execution of the DTS package. I have trimmed and tuned the
stored procedures to be much smaller and faster, but still
haven't beaten the timeout. How do i avoid, switch off, or
lengthen the timeout period?

Thanks, Joshua

PS, alternately, how might I modify the parameters of and execute
DTS packages from stored procedures?